package com.example.mapper;

import com.example.pojo.bo.LearningExperienceBO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 本文来演示:
 *
 * @author 赵建云
 * @create 2023/10/4
 */
public interface LearningExperienceMapper {
    @Select("select background,sc_name,sc_type from learning_experience where js_id = #{value}")
    LearningExperienceBO searchAll(Integer jsId);
    @Select("select js_id from learning_experience where sc_name=#{value} or background=#{value} or specialty=#{value}")
    List<Integer> searchByWord(String search);

    List<Integer> searchByBackground(@Param("background") Integer background);
    List<Integer> searchByType(@Param("type") Integer type);

}
